#!/bin/sh

CURRENT_SCRIPT_NAME=`basename $0`
echo Current script name is "$CURRENT_SCRIPT_NAME"
if [ "$CURRENT_SCRIPT_NAME" != "mac-devdeploy.sh" ]
then
	set -x
	IS_POSTFLIGHT=true
	echo "RUNNING POSTFLIGHT SCRIPT..."
else
	IS_POSTFLIGHT=false
	echo "RUNNING DEV DEPLOY SCRIPT..."
fi

PRODUCT_DIRECTORY_NAME="Universal Type Server"
PRODUCT_BONJOUR_SERVICE_NAME="Universal Type Server"
PRODUCT_APP_ABBR="uts"
PRODUCT_DOMAIN_NAME="font"

if $IS_POSTFLIGHT;
then
	EXTENSIS_APPS_HOME=$2/Extensis
else
	EXTENSIS_APPS_HOME=/Applications/Extensis
fi

PRODUCT_HOME="$EXTENSIS_APPS_HOME"/"$PRODUCT_DIRECTORY_NAME"

DEPLOYED_APPLICATIONS_DIR="$PRODUCT_HOME"/applications
DEPLOYED_DATA_DIR="$PRODUCT_HOME"/data
DEPLOYED_SCRIPTS_DIR="$DEPLOYED_DATA_DIR"/scripts
DEPLOYED_LOGS_DIR="$PRODUCT_HOME"/logs
PRODUCT_LIBRARY_HOME=/Library/Extensis/UTS
PG_APP_DIR="$PRODUCT_LIBRARY_HOME"/pgsql

DEFAULT_KERBEROS_SPN=universaltype

ESP_ADMIN="$DEPLOYED_APPLICATIONS_DIR"/esp-admin.sh
ESP_DEPLOYER="$DEPLOYED_APPLICATIONS_DIR"/espdeployer.sh

DEPLOY_TMP_DIR=/private/tmp

if [ ! -d "$PG_APP_DIR" ]; then
	#/Library/Extensis/UTS/pgsql doesn't exist, create it
	echo making directory ${PG_APP_DIR}
	mkdir -p "$PG_APP_DIR" > /dev/null 2>&1
fi

if $IS_POSTFLIGHT;
then
	# Run the script from a temp directory we know will stick around (fixes bug IP 38662)
	# This only needs to be done when this script is called by the installer (at which point it
	# has been renamed to "postflight")               moving pgsql from /Applications/Extensis/pgsql to /Library/Extensis/UTS/pgsql
	echo Changing directories to "$DEPLOY_TMP_DIR"
	cd "$DEPLOY_TMP_DIR"
	cp -Rf "$PRODUCT_HOME"/pgsql "$PRODUCT_LIBRARY_HOME"
    rm -rf "$PRODUCT_HOME"/pgsql
else
	# copy the deploy folders directly when run as mac-devdeploy.sh script
	echo "COPYING DEPLOY FOLDERS..."
	
	mkdir "$EXTENSIS_APPS_HOME"
	mkdir "$PRODUCT_HOME"
	
	# Copy deployables
	cp -R ./applications/ "$DEPLOYED_APPLICATIONS_DIR"
	cp -R ./data/ "$DEPLOYED_DATA_DIR"
	cp -R ./logs/ "$DEPLOYED_LOGS_DIR"
	cp -R ./pgsql "$PRODUCT_LIBRARY_HOME"
fi

sudo mkdir "$DEPLOYED_DATA_DIR"/sso

chmod a+x "$ESP_DEPLOYER"

#===========================================================================================
# SET APPLICATION PREFERENCES
#===========================================================================================

echo "======= SET APPLICATION PREFERENCES ======="

# Remove previous preferences
"$ESP_DEPLOYER" -deletepreference server.state	
"$ESP_DEPLOYER" -deletepreference server.transitional.state
"$ESP_DEPLOYER" -deletepreference server.access.state

# Install Server preferences (these ARE deleted first so they DON'T retain existing values)
"$ESP_DEPLOYER" -deletepreference server.home
"$ESP_DEPLOYER" -addpreference server.home="$PRODUCT_HOME"
"$ESP_DEPLOYER" -deletepreference jboss.home
"$ESP_DEPLOYER" -addpreference jboss.home="$DEPLOYED_APPLICATIONS_DIR"/jboss
"$ESP_DEPLOYER" -deletepreference jetty.home
"$ESP_DEPLOYER" -addpreference jetty.home="$DEPLOYED_APPLICATIONS_DIR"/jetty

# Install Server preferences (these are NOT deleted first so they DO retain existing values)
"$ESP_DEPLOYER" -addpreference backup.dir="$PRODUCT_HOME"/data/backups
"$ESP_DEPLOYER" -addpreference backup.schedule="0 0 3 ? * sun"
"$ESP_DEPLOYER" -addpreference backup.max.backups=3
"$ESP_DEPLOYER" -addpreference vault.home="$PRODUCT_HOME"/data/vault
"$ESP_DEPLOYER" -addpreference server.bonjour.advertise.name="$PRODUCT_BONJOUR_SERVICE_NAME"
"$ESP_DEPLOYER" -addpreference server.bonjour.advertise=true
"$ESP_DEPLOYER" -addpreference admin.url="http://localhost:18081"
"$ESP_DEPLOYER" -addpreference autostart.dir=/Library/StartupItems/"$PRODUCT_DIRECTORY_NAME"/

#===========================================================================================
# INSTALL POSTGRES
#===========================================================================================

echo "======= INIT POSTGRES ======="

PG_BIN_DIR="${PG_APP_DIR}"/bin
PG_DATA_DIR="${PRODUCT_LIBRARY_HOME}"/pgdata
PG_SUPERUSER=postgres
PG_SUPERUSER_PASSWD="veDfmfIRfbF5+xjtBwCaYPWORnA="
PG_PORT=15432 # TODO: query system for unused port
DB_NAME=UTS
ENCODING=UTF8
PG_USER=uts
PG_USER_PASSWORD=esp
PG_PLIST=com.extensis.uts_db.plist

USERNAME="_uts"
USERPATH="/Users/${USERNAME}"
maxid=$(dscl . -list /Users UniqueID | awk '{print $2}' | sort -ug | tail -1)
USERID=$((maxid+1))
GROUPID="1" # daemon group
USERREALNAME="Universal Type Server User"
NOPASSWORD="*"
USERSHELL="/bin/bash"
NOHOMEDIR="/var/empty"
NOUSERSHELL="usr/bin/false"
PG_PASS_FILE="${PG_APP_DIR}"/.pgpass

# create user
sudo dscl . create "${USERPATH}" UniqueID "${USERID}"
sudo dscl . create "${USERPATH}" PrimaryGroupID "${GROUPID}"
sudo dscl . create "${USERPATH}" NFSHomeDirectory "${PG_HOME_DIR}"
sudo dscl . create "${USERPATH}" UserShell "${USERSHELL}"
sudo dscl . create "${USERPATH}" RealName "${USERREALNAME}"
sudo dscl . create "${USERPATH}" Password "${NOPASSWORD}"

# make home directory and set permissions for it
sudo chown -R ${USERNAME} "${PG_APP_DIR}"

# create a .pgpass file which allows the _uts user to
# authenticate from its home directory on the local machine
# without a password prompt
sudo touch "${PG_PASS_FILE}"
sudo chmod 666 "${PG_PASS_FILE}"
sudo echo localhost:"${PG_PORT}":*:"${PG_SUPERUSER}":"${PG_SUPERUSER_PASSWD}" > "${PG_PASS_FILE}"
sudo chmod 600 "${PG_PASS_FILE}"
sudo chown "${USERNAME}" "${PG_PASS_FILE}"

# set permissions on the product library directory
sudo chmod 777 "${PRODUCT_LIBRARY_HOME}"

if [ -d "${PG_DATA_DIR}" ];
then
     POSTGRES_DATABASE_EXISTS=true;
     echo "$PG_DATA_DIR already exists; don't overwrite database" ;
	  chown -R ${USERNAME} "$PG_DATA_DIR";
else
     POSTGRES_DATABASE_EXISTS=false;
     echo "Postgres database does not exist; creating Postgres database";
     sudo -u ${USERNAME} "${PG_BIN_DIR}"/pg_ctl initdb --silent --pgdata "${PG_DATA_DIR}" -o "--encoding=${ENCODING} --username=${PG_SUPERUSER} --auth trust";

     echo Setting server requirements;
     sudo mv "${PG_APP_DIR}"/postgresql.conf "${PG_DATA_DIR}"/postgresql.conf;
     sudo chown "${USERNAME}" "${PG_DATA_DIR}"/postgresql.conf;
     sudo chmod 600 "${PG_DATA_DIR}"/postgresql.conf;

     sudo mv "${PG_APP_DIR}"/pg_hba.conf "${PG_DATA_DIR}"/pg_hba.conf;
     sudo chown "${USERNAME}" "${PG_DATA_DIR}"/pg_hba.conf;
     sudo chmod 600 "${PG_DATA_DIR}"/pg_hba.conf;
fi

if [ -f "$DEPLOYED_DATA_DIR"/database/esp.dbn ];
then
    POINTBASE_DATABASE_EXISTS=true;
    echo Pointbase database exists;
else
    POINTBASE_DATABASE_EXISTS=false;
    echo Pointbase database does not exist;
fi

# install the launch daemon plist
sudo mv "${PG_APP_DIR}"/"${PG_PLIST}" /Library/LaunchDaemons/;
sudo chown root:wheel /Library/LaunchDaemons/"${PG_PLIST}";
sudo chmod 644 /Library/LaunchDaemons/"${PG_PLIST}";

# start postgres
echo launching postgres;
sudo launchctl load /Library/LaunchDaemons/"${PG_PLIST}";

# wait for postgres to start up, time out after 30 seconds if for some reason it doesn't start
COUNT=0;
POSTGRES_IS_RUNNING=0;

while [ $COUNT -le 30 ]
do
	sleep 1;
	(( COUNT++ ));
	# check the status of postgres, the return code will be 0 if it is running
	sudo chmod g+rw ${PG_DATA_DIR}/postmaster.pid;
	sudo -u ${USERNAME} "${PG_BIN_DIR}"/pg_ctl status --pgdata "${PG_DATA_DIR}";
	# get the return code
	POSTGRES_IS_RUNNING=$?;
	if [ $COUNT -gt 30 ];
	then
		echo postgres failed to start after 30 seconds, exiting...;
		exit 1;
	fi
	if [ $POSTGRES_IS_RUNNING -ne 0 ];
	then
		echo waiting for postgres to start...;
		echo "postgres not yet started after $COUNT second(s)...";
	else
		echo postgres is started...;
		break;
	fi
done

if $POSTGRES_DATABASE_EXISTS;
then
    echo Database user and database already exist.;
else
    # create the application user
    sudo -u "${USERNAME}" "${PG_BIN_DIR}"/psql -U ${PG_SUPERUSER} -p ${PG_PORT} -c "CREATE ROLE ${PG_USER} WITH CREATEDB LOGIN ENCRYPTED PASSWORD '${PG_USER_PASSWORD}';";

    # create the database
    sudo -u "${USERNAME}" "${PG_BIN_DIR}"/createdb -U ${PG_SUPERUSER} -p ${PG_PORT} -E ${ENCODING} -O ${PG_USER} $DB_NAME;
fi

# now that we are done using the uts user, adjust settings as appropriate for a deamon, i.e.
# no shell, home directory, or authentication authority. This way the user will not appear
# in the GUI login and accounts screens, nor will it be able to log in remotely.
sudo dscl . change "${USERPATH}" NFSHomeDirectory "${PG_HOME_DIR}" "${NOHOMEDIR}";
sudo dscl . change "${USERPATH}" UserShell "${USERSHELL}" "${NOUSERSHELL}";
sudo dscl . delete "${USERPATH}" AuthenticationAuthority;

#===========================================================================================
# MODIFY PERMISSIONS
#===========================================================================================

echo "======= MODIFY PERMISSIONS ======="

# Remove the old demo cookie file if it exists
if [ -f /usr/bin/.fhqwgads.dat ];
then
	sudo rm /usr/bin/.fhqwgads.dat;
fi

# chown to root for application files.
sudo chown -R root "$PRODUCT_HOME";

# chgrp to wheel for application files.
sudo chgrp -R wheel "$PRODUCT_HOME";

# chmod +x any executables
sudo chmod a+x "$DEPLOYED_APPLICATIONS_DIR"/jboss/bin/*.sh;
sudo chmod a+x "$DEPLOYED_APPLICATIONS_DIR"/*.sh;
sudo chmod a+x "$DEPLOYED_APPLICATIONS_DIR"/jetty/*.sh;

# Restore previously saved Server preferences (this is to retain configuration params across an upgrade install)
echo "RESTORING ANY PREVIOUS VERSION'S CONFIGURATION PARAMETERS...";
sudo "$ESP_ADMIN" -restoreserversettings;

if $IS_POSTFLIGHT;
then
	# chown jetty to root
	chown root /Library/LaunchDaemons/com.extensis.server.web.admin.launchd.plist;
	
	# chgrp jetty to wheel
	chgrp wheel /Library/LaunchDaemons/com.extensis.server.web.admin.launchd.plist;
	
	# start jetty by loading the launchd item
	sudo launchctl load /Library/LaunchDaemons/com.extensis.server.web.admin.launchd.plist;
fi

#===========================================================================================
# INIT DB
#===========================================================================================

echo "======= INIT DATABASE ======="

###### Functions ######
getPreferences(){
    database_dialect=`sudo "$ESP_DEPLOYER" -getpreference db.driver.name`
    echo Database dialect is: $database_dialect
}

# This function will install the 4.0 schema.
# We usually write incremental sql scripts to upgrade from one version to the next,
# but in the case of the 3.2 -> 4.0 (for Pointbase), we convert from Pointbase to Postgres.
# This requires creating a new database at the 4.0 schema.
initDb40(){
    echo "===> BEGIN INIT NEW 4.0 DB"

    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/esp.core.create-tables.{\$dbdialect}-4.0.sql
    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/"$PRODUCT_DOMAIN_NAME".create-tables.{\$dbdialect}-4.0.sql
    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/test.create-tables.{\$dbdialect}-4.0.sql

    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/esp.core.insert-domain.{\$dbdialect}-4.0.sql
    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/"$PRODUCT_DOMAIN_NAME".insert-domain.{\$dbdialect}-4.0.sql
    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/test.insert-domain.{\$dbdialect}-4.0.sql

    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/"$PRODUCT_DOMAIN_NAME"-data.{\$dbdialect}-4.0.sql

    echo "===> END INIT NEW 4.0 DB"
}

initDb(){
    echo "===> BEGIN INIT NEW DB"

    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/esp.core.create-tables.{\$dbdialect}.sql
    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/"$PRODUCT_DOMAIN_NAME".create-tables.{\$dbdialect}.sql
    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/test.create-tables.{\$dbdialect}.sql

    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/esp.core.insert-domain.{\$dbdialect}.sql
    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/"$PRODUCT_DOMAIN_NAME".insert-domain.{\$dbdialect}.sql
    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/test.insert-domain.{\$dbdialect}.sql

    sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/"$PRODUCT_DOMAIN_NAME"-data.{\$dbdialect}.sql

    echo "===> END INIT NEW DB"
}

setPostgresDriver(){

    # In the case Pointbase is specified force moving to Postgres
    if [[ $database_dialect = "esp.database.driver.Embedded" ]];
    then
        "$ESP_DEPLOYER" -deletepreference db.driver.name
        "$ESP_DEPLOYER" -deletepreference db.host.name
        "$ESP_DEPLOYER" -deletepreference db.host.port
        "$ESP_DEPLOYER" -deletepreference db.db.name
        "$ESP_DEPLOYER" -deletepreference db.user
        "$ESP_DEPLOYER" -deletepreference db.password
    fi

    # If these preferences are already set they won't be overwritten (In the case of an external database)
    # Forces a null db.driver.name to PostgreSQL
    "$ESP_DEPLOYER" -addpreference db.driver.name="esp.database.driver.PostgreSQL"
    "$ESP_DEPLOYER" -addpreference db.host.name="localhost"
    "$ESP_DEPLOYER" -addpreference db.host.port="15432"
    "$ESP_DEPLOYER" -addpreference db.db.name="UTS"
    "$ESP_DEPLOYER" -addpreference db.user="uts"
    "$ESP_DEPLOYER" -addpreference db.password="esp"

    getPreferences
}

###### End Functions ######

getPreferences

# Upgrade to 4
if $POSTGRES_DATABASE_EXISTS || $POINTBASE_DATABASE_EXISTS ;
then
    echo Upgrade scenario

	# If the version file does not exist, then assume current version is 1.0
	if [ -f "$DEPLOYED_DATA_DIR"/version ];
	then
		# Read contents of the version file
		CURRENT_UTS_DB_VERSION=`sudo tail -n1 "$DEPLOYED_DATA_DIR"/version | sed 's/[ \r\n]*$//'`
	else
		CURRENT_UTS_DB_VERSION=1.0;
	fi

	echo ===> Current UTS version is: $CURRENT_UTS_DB_VERSION
	if [ $CURRENT_UTS_DB_VERSION = "1.0" ] && $POSTGRES_DATABASE_EXISTS;
	then
	   echo ERROR: The pgdata directory exists but version information has been deleted. Please contact technical support for assistance
	   exit 1
	fi

	if [ $CURRENT_UTS_DB_VERSION = "1.0" ];
	then
		echo ERROR: This version of UTS does not support converting 1.0 databases
		exit 1
	fi

	if [ $CURRENT_UTS_DB_VERSION = "1.0.1" ];
	then
		echo ERROR: This version of UTS does not support converting 1.0.1 databases
		exit 1
	fi

	if [ $CURRENT_UTS_DB_VERSION = "2.0" ];
	then
		echo ERROR: This version of UTS does not support converting 1.0.1 databases
        exit 1
	fi

	if [ $CURRENT_UTS_DB_VERSION = "2.1" ];
	then
		echo Converting 2.1 database to 3.0
		sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/update_2.1_To_3.0.{\$dbdialect}.sql
		sudo echo 3.0> "$DEPLOYED_DATA_DIR"/version
		CURRENT_UTS_DB_VERSION=3.0
	fi

	if [ $CURRENT_UTS_DB_VERSION = "3.0" ];
	then
		echo Converting 3.0 database to 3.1
		sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/update_3.0_To_3.1.{\$dbdialect}.sql
		sudo echo 3.1> "$DEPLOYED_DATA_DIR"/version
		CURRENT_UTS_DB_VERSION=3.1
	fi

	if [ $CURRENT_UTS_DB_VERSION = "3.1" ];
	then
		echo Converting 3.1 database to 3.2
		sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/update_3.1_To_3.2.{\$dbdialect}.sql
		sudo echo 3.2> "$DEPLOYED_DATA_DIR"/version
		CURRENT_UTS_DB_VERSION=3.2
	fi

	if [ $CURRENT_UTS_DB_VERSION = "3.2" ];
	then
		echo Converting 3.2 database to 4.0
		sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/update_3.2_To_4.0.{\$dbdialect}.sql
		# if the database is Pointbase then create the Postgres Database
		if [[ $database_dialect = "esp.database.driver.Embedded" ]] || [[ $database_dialect = "" ]] || [[ $database_dialect = "esp.null" ]]
		then
			# Since the esp_deployer command infers the dialect, we must set it here.
			# If the driver was Pointbase, it will be set to Postgres
			# If the driver was MySQL or SQLServer, the value will be honored.
			setPostgresDriver

			initDb40

			echo Converting $CURRENT_UTS_DB_VERSION database to PostgreSQL
			sudo "$ESP_DEPLOYER" -migratepointbase
		else
			echo Database is $database_dialect, do not migrate to Postgres
		fi
		sudo echo 4.0> "$DEPLOYED_DATA_DIR"/version
		CURRENT_UTS_DB_VERSION=4.0
	fi

    if [ $CURRENT_UTS_DB_VERSION = "4.0" ];
    then
       	echo Converting 4.0 database to 4.1
       	sudo "$ESP_DEPLOYER" -runsql "$DEPLOYED_SCRIPTS_DIR"/update_4.0_To_4.1.{\$dbdialect}.sql
        sudo echo 4.1> "$DEPLOYED_DATA_DIR"/version
        CURRENT_UTS_DB_VERSION=4.1
    fi

    if [ $CURRENT_UTS_DB_VERSION = "4.1" ];
    then
       echo Updating version to 4.2 no conversion needed
       sudo echo 4.2> "$DEPLOYED_DATA_DIR"/version
       CURRENT_UTS_DB_VERSION=4.2
    fi

# Clean install
else
    echo Clean installation.
    setPostgresDriver
    initDb
fi

# Create Datasource
# This must be done after we set the driver Preferences
sudo "$ESP_DEPLOYER" -createdatasource

# Also fix up login-config.xml for kerberisation compatibility:
echo "CONFIGURING LOGIN FOR KERBEROS COMPATIBILITY..."
sudo "$ESP_DEPLOYER" -createloginconfig "$DEFAULT_KERBEROS_SPN"

#===========================================================================================
# DEPLOYING
#===========================================================================================

echo "======= DEPLOYING ======="

sudo echo 4.2> "$DEPLOYED_DATA_DIR"/version

echo "Deploying $PRODUCT_APP_ABBR.ear"

sudo "$ESP_DEPLOYER" -deploy "$DEPLOYED_APPLICATIONS_DIR"/"$PRODUCT_APP_ABBR".ear

echo "Creating startup item"
sudo mkdir /Library/StartupItems
sudo chgrp wheel /Library/StartupItems
sudo "$ESP_ADMIN" -username administrator -password password -setautostart enabled

echo "Creating admin log"
# Make the admin log, and make sure it is writable by all
sudo mkdir "$DEPLOYED_LOGS_DIR"
sudo chmod a+w "$DEPLOYED_LOGS_DIR"

# TODO: should be product-specific, e.g. BoilerplateServer.admin.log
sudo touch "$DEPLOYED_LOGS_DIR"/extensis.admin.log
sudo chmod a+w "$DEPLOYED_LOGS_DIR"/extensis.admin.log

if $IS_POSTFLIGHT;
then
	# Start up the server by invoking the jboss run script
	sudo "$DEPLOYED_APPLICATIONS_DIR/jboss/bin/run.sh"
	echo
	sleep 5
	# Start up the script that waits for the installer to finish and then launches admin web app
	sudo nohup "$DEPLOYED_APPLICATIONS_DIR"/WaitToQuitInstall.sh "$2"&
else
	echo "To start the server: "
	echo "sudo \"$DEPLOYED_APPLICATIONS_DIR/jboss/bin/run.sh\""
	echo
	echo "To start jetty:"
	echo "cd \"$DEPLOYED_APPLICATIONS_DIR/jetty\""
	echo "sudo ./launch-jetty.sh"
fi
